UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9vptQumFvIqGtBE8E9VSOz6CXHoMfdcGgTEJ2g2IKKs='
WHERE
key_id = '8a4dfed385c58425502b125558f3566ce035dfd2d7051a8c05cc34f19701a186'
AND (
token = '9vptQumFvIqGtBE8E9VSOz6CXHoMfdcGgTEJ2g2IKKs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)