UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DxAl3Ee/8CHk2idaTFETS4p2T0G4EgN7FNfRyqfQ8Yk='
WHERE
key_id = '3f78ca356636866a915d7dd25b9654946be024934791f2fd1e97d259c7f9c63f'
AND (
token = 'DxAl3Ee/8CHk2idaTFETS4p2T0G4EgN7FNfRyqfQ8Yk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)