UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r0nO0MgBYx13g6EFHf9C7DXHZcrGnyPlHmpce8y6fS0='
WHERE
key_id = '7ea2bc29dd432d6f1fe2582229a1df5ad13cb19f5a29d28f2144650b9c73fb67'
AND (
token = 'r0nO0MgBYx13g6EFHf9C7DXHZcrGnyPlHmpce8y6fS0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)