UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v4RyoqrlY3NpwfbENw8IN7cPurrDLsemxRzpzyI+eFk='
WHERE
key_id = 'f91c1d76cf9fa5247722d95e95de4bcfb0f28d122cc3415ad023d41f4e00b4cb'
AND (
token = 'v4RyoqrlY3NpwfbENw8IN7cPurrDLsemxRzpzyI+eFk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)