UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mJ4nMXgKhUqvvQKGGKRObDkLw3wHfVgmt3dS6hAqKfU='
WHERE
key_id = '6adabe708c6c39b68be43eb18b17ea8d557bb2e9917b60f5bf6e9be563c144bb'
AND (
token = 'mJ4nMXgKhUqvvQKGGKRObDkLw3wHfVgmt3dS6hAqKfU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)