UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hPr5J4ShaxEmzKUH3twdArpSlfz4eZmzYU3+iFg0dMA='
WHERE
key_id = '99a46d6d2857dd067d02f930bad951522313b5fc00f28f7c0806738f6f9bff22'
AND (
token = 'hPr5J4ShaxEmzKUH3twdArpSlfz4eZmzYU3+iFg0dMA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)