UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'h9UHE2QqRWUF+7D0ZVBgbvRaKq6BUTeu9spioW/hlXs='
WHERE
key_id = 'be28928ac2c6701c6b91a04a32eefab4334136989392031ccf3f1ace22e45642'
AND (
token = 'h9UHE2QqRWUF+7D0ZVBgbvRaKq6BUTeu9spioW/hlXs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)