UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9r5+qqWm6wv6OePrhocq0Cz5M11X5vl15Hl/FvBtHdA='
WHERE
key_id = '8b1065c840fb74f826304d83459f3c8ee1a0ef84e8d6b789fd30b010c5863227'
AND (
token = '9r5+qqWm6wv6OePrhocq0Cz5M11X5vl15Hl/FvBtHdA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)