UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lCEG7VsszuawG4OHYTOSbBaNHPHsG1LzvRz5KmRqAUU='
WHERE
key_id = 'fc0d2677bcfa4a2d5c2a4b9a96dab5989725e952b84de5149a3eb680c182f623'
AND (
token = 'lCEG7VsszuawG4OHYTOSbBaNHPHsG1LzvRz5KmRqAUU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)