UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PZCFQZCN99xDgUsoU4qa2jRHDDKCcmDI24foql6hHGs='
WHERE
key_id = '028c1916bab9ffc0ef954cb3e0548461fd4d58f76a86fe69f00a9634a21eff4c'
AND (
token = 'PZCFQZCN99xDgUsoU4qa2jRHDDKCcmDI24foql6hHGs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)