UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W2FnAX+UwoE1xa6oOzrEfvVxRZJAKvAlKwENzynpqoQ='
WHERE
key_id = '2d06805e646869d5c945fff07f60e21dca85a928118e7c30f26f7d099a72033f'
AND (
token = 'W2FnAX+UwoE1xa6oOzrEfvVxRZJAKvAlKwENzynpqoQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)