UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MsgNQIW3cLcYYhf+O5KjejFImLfexpq+ZPmVv360kjc='
WHERE
key_id = 'a3f23d34306a421b4e926263da40f5ad6b53cf5388a71fcdcff143e2b9d0906a'
AND (
token = 'MsgNQIW3cLcYYhf+O5KjejFImLfexpq+ZPmVv360kjc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)