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