UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0fKYjak2BlBNDZMu85k0KD/IRqZYGZAp1aevc8B5p+4='
WHERE
key_id = 'b6630a9904c5e5fef1305b25cac9b08e61151111ae19d07f5054de96ba2980c6'
AND (
token = '0fKYjak2BlBNDZMu85k0KD/IRqZYGZAp1aevc8B5p+4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)