UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MoBSdAF2dLNRYXG7ktYHTiSaSX4JxTxwOE65jmqbUms='
WHERE
key_id = '9011612542279ca9ce6ef700270c8d21f68a08b0075e6b6584dfbabe74c8256a'
AND (
token = 'MoBSdAF2dLNRYXG7ktYHTiSaSX4JxTxwOE65jmqbUms='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)