UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8QqXp9qAfof8lAIA1vX2srTYPtHoqtfWTLRt5kj4ZvE='
WHERE
key_id = '17a02f2fb026731e995e2e0109910c7e32c8245e56a1073e9701a343a9a3c102'
AND (
token = '8QqXp9qAfof8lAIA1vX2srTYPtHoqtfWTLRt5kj4ZvE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)