UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7YUM8Et80qjwaorUikqkoC1PN0l4GmlSn2dmojgyQ3o='
WHERE
key_id = 'ae37a5d6d3aa80e294cccee15b87b735cf85ad26e0253837b3d4a492e9f30b1b'
AND (
token = '7YUM8Et80qjwaorUikqkoC1PN0l4GmlSn2dmojgyQ3o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)