UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fAnLV66Xiz4y25QnCASrVzRZYxpP4BpInb8k6l1VFvk='
WHERE
key_id = '71443f9751df8ecfc07ffaf8aa231a742216201f09feafac8c4a76117902fd93'
AND (
token = 'fAnLV66Xiz4y25QnCASrVzRZYxpP4BpInb8k6l1VFvk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)