UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XB8SwApAbTISLwpBI0qdXniWm9NHuXjyA1kpc7X8U4s='
WHERE
key_id = '43284f8dc4924b8b653764129cb204b4268cc0d81a30653b2f5b29a8febbca53'
AND (
token = 'XB8SwApAbTISLwpBI0qdXniWm9NHuXjyA1kpc7X8U4s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)