UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2EGo9oPtf9TcVu8kOuknJqMNZQBLRfvpX1Ace5TBhxs='
WHERE
key_id = '8a12c0402910b708dfa58d8250767536eaae236a9ae1e57997579139b47efdd7'
AND (
token = '2EGo9oPtf9TcVu8kOuknJqMNZQBLRfvpX1Ace5TBhxs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)