UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g9YZJx+QTwmVf5dgS+Xi8Oar5tQpTN14XkxROsfwWZ4='
WHERE
key_id = 'a4b4bf427e39dd99b6278ed259c08b0b8f98fb094a06a1a5d73a007eb9bdc9e2'
AND (
token = 'g9YZJx+QTwmVf5dgS+Xi8Oar5tQpTN14XkxROsfwWZ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)