UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nYAJ4jzsV+XRJSl/NzvWr4wQDlonRpoSp2WkclAo73I='
WHERE
key_id = 'fe01c04f4f3daa14d5013d358e91b3a540371b400c3228a9bc6fc8d67dc308ab'
AND (
token = 'nYAJ4jzsV+XRJSl/NzvWr4wQDlonRpoSp2WkclAo73I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)