UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fa6K8fJmazuD5PNdlKAvfbliBZUiIcOvxhj3hM9jzL8='
WHERE
key_id = 'ac5e625430c61861432b7a2763171b23e5802817bedfc4a571c960a60a49babc'
AND (
token = 'fa6K8fJmazuD5PNdlKAvfbliBZUiIcOvxhj3hM9jzL8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)