UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BfrZ8aU2MqzCp3RDocGwJRbmwJLEPdzrbH+5o+jcYAo='
WHERE
key_id = '8eb6b33908582cf64a18cfa27daf94bc6e3ac9acf65196474ea79083604a8410'
AND (
token = 'BfrZ8aU2MqzCp3RDocGwJRbmwJLEPdzrbH+5o+jcYAo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)