UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6L515sqcl5OgP+S41YUwtdCS3t3O7b+saEen0JOAPYc='
WHERE
key_id = '840f869fa8423a719b9a9ed927eabb56501e49d479a86bde019fb6a53f599742'
AND (
token = '6L515sqcl5OgP+S41YUwtdCS3t3O7b+saEen0JOAPYc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)