UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hrYEkr8whbxhS5dw7Nk2lX36bRe7WIzN9aGZJEhXty0='
WHERE
key_id = '186d3ffa90842ee33a9089a6a41b7dc2f8bcbf822ef50ccc674cae96b670374f'
AND (
token = 'hrYEkr8whbxhS5dw7Nk2lX36bRe7WIzN9aGZJEhXty0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)