UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DTi5IgWJvNJc7B7rlxIiO0P8RTzIKw7zb2qtJREfbis='
WHERE
key_id = '22e7c756238d463b8fe3288bdb1d7d0a87c4793d5da289927a365f1d44d0f927'
AND (
token = 'DTi5IgWJvNJc7B7rlxIiO0P8RTzIKw7zb2qtJREfbis='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)