UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sF8W5Dx5MXGe6r30Hww09YjjxhzPlBEFgvUvMqgd6Bs='
WHERE
key_id = '04ca35acaf79fd9320b254cbad29bc6870dfb90d149c836c541bd8d7372007ab'
AND (
token = 'sF8W5Dx5MXGe6r30Hww09YjjxhzPlBEFgvUvMqgd6Bs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)