UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BxGSiHRP5SQ7xHIrVrN/er11zqEThm9rvkasC02GiAo='
WHERE
key_id = 'b2564cecbebd5bd6f9220921dc5c04056bb6e6821d009d0c3cb8049099fc4b42'
AND (
token = 'BxGSiHRP5SQ7xHIrVrN/er11zqEThm9rvkasC02GiAo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)