UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TnVkTI1hKf0vQEhd3d2IJaYydg2g0Lxvaje5+ZEiPdg='
WHERE
key_id = 'c566f0ad882de951a1a29ded64be0fc33cfb6819a1f714269c91eef1de7407e9'
AND (
token = 'TnVkTI1hKf0vQEhd3d2IJaYydg2g0Lxvaje5+ZEiPdg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)