UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L+WVTwxWmpm8qqXLHhPjwuan/rEIjzVKh9u6T220uSg='
WHERE
key_id = '2c5065f02f2b345a636981fe8ccf1b626cf377c875a031b9f39ba576fcc4b62a'
AND (
token = 'L+WVTwxWmpm8qqXLHhPjwuan/rEIjzVKh9u6T220uSg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)