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